/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50715
 Source Host           : localhost:3306
 Source Schema         : onliine

 Target Server Type    : MySQL
 Target Server Version : 50715
 File Encoding         : 65001

 Date: 24/10/2023 16:59:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(255) NOT NULL,
  `admin_password` varchar(255) NOT NULL,
  `role_id` varchar(11) DEFAULT NULL,
  `salt` varchar(6) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `nav_id` varchar(50) DEFAULT '0',
  `status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1是百战 2是考试系统',
  `type` varbinary(50) DEFAULT NULL COMMENT 'company公司套卷 university大学套卷  society社会',
  `companyId` int(11) DEFAULT NULL,
  `universityId` int(11) DEFAULT NULL,
  `hide` enum('yes','no') NOT NULL DEFAULT 'no' COMMENT '是否隐藏',
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin', '2c8b9c7b2e22946f686f511185d0c27a', '1', '', '', '0', '1', NULL, NULL, NULL, 'no');
COMMIT;

-- ----------------------------
-- Table structure for admin_comment
-- ----------------------------
DROP TABLE IF EXISTS `admin_comment`;
CREATE TABLE `admin_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `admin_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `comment` varchar(50) NOT NULL COMMENT '''positive'',''middle'',''negative''',
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `method` varchar(10) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `input` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=354 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_log` VALUES (1, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:06:45', '2023-10-08 15:06:45');
INSERT INTO `admin_log` VALUES (2, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:08:00', '2023-10-08 15:08:00');
INSERT INTO `admin_log` VALUES (3, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:08:00', '2023-10-08 15:08:00');
INSERT INTO `admin_log` VALUES (4, 1, 'admin/index_nav/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:08:01', '2023-10-08 15:08:01');
INSERT INTO `admin_log` VALUES (5, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:47', '2023-10-08 15:09:47');
INSERT INTO `admin_log` VALUES (6, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:47', '2023-10-08 15:09:47');
INSERT INTO `admin_log` VALUES (7, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:49', '2023-10-08 15:09:49');
INSERT INTO `admin_log` VALUES (8, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"is_course\":\"no\"}', '2023-10-08 15:09:50', '2023-10-08 15:09:50');
INSERT INTO `admin_log` VALUES (9, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:51', '2023-10-08 15:09:51');
INSERT INTO `admin_log` VALUES (10, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:52', '2023-10-08 15:09:52');
INSERT INTO `admin_log` VALUES (11, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:09:57', '2023-10-08 15:09:57');
INSERT INTO `admin_log` VALUES (12, 1, 'admin/training/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:01', '2023-10-08 15:10:01');
INSERT INTO `admin_log` VALUES (13, 1, 'admin/package/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:02', '2023-10-08 15:10:02');
INSERT INTO `admin_log` VALUES (14, 1, 'admin/handout/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:03', '2023-10-08 15:10:03');
INSERT INTO `admin_log` VALUES (15, 1, 'admin/handout/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:05', '2023-10-08 15:10:05');
INSERT INTO `admin_log` VALUES (16, 1, 'admin/admin/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:07', '2023-10-08 15:10:07');
INSERT INTO `admin_log` VALUES (17, 1, 'admin/role/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:07', '2023-10-08 15:10:07');
INSERT INTO `admin_log` VALUES (18, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:08', '2023-10-08 15:10:08');
INSERT INTO `admin_log` VALUES (19, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:09', '2023-10-08 15:10:09');
INSERT INTO `admin_log` VALUES (20, 1, 'admin/admin/pass', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:11', '2023-10-08 15:10:11');
INSERT INTO `admin_log` VALUES (21, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:13', '2023-10-08 15:10:13');
INSERT INTO `admin_log` VALUES (22, 1, 'admin/order/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:16', '2023-10-08 15:10:16');
INSERT INTO `admin_log` VALUES (23, 1, 'admin/user/question', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:16', '2023-10-08 15:10:16');
INSERT INTO `admin_log` VALUES (24, 1, 'admin/training/lists', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:17', '2023-10-08 15:10:17');
INSERT INTO `admin_log` VALUES (25, 1, 'admin/other/question', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:18', '2023-10-08 15:10:18');
INSERT INTO `admin_log` VALUES (26, 1, 'admin/user/count', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:18', '2023-10-08 15:10:18');
INSERT INTO `admin_log` VALUES (27, 1, 'admin/index/question', 'GET', '127.0.0.1', '[]', '2023-10-08 15:10:34', '2023-10-08 15:10:34');
INSERT INTO `admin_log` VALUES (28, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:16:51', '2023-10-08 15:16:51');
INSERT INTO `admin_log` VALUES (29, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:16:51', '2023-10-08 15:16:51');
INSERT INTO `admin_log` VALUES (30, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-08 15:16:53', '2023-10-08 15:16:53');
INSERT INTO `admin_log` VALUES (31, 1, 'admin/sub/ques_edit', 'GET', '127.0.0.1', '[]', '2023-10-08 15:16:57', '2023-10-08 15:16:57');
INSERT INTO `admin_log` VALUES (32, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 15:17:07', '2023-10-08 15:17:07');
INSERT INTO `admin_log` VALUES (33, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 15:41:51', '2023-10-08 15:41:51');
INSERT INTO `admin_log` VALUES (34, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:41:51', '2023-10-08 15:41:51');
INSERT INTO `admin_log` VALUES (35, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 15:44:51', '2023-10-08 15:44:51');
INSERT INTO `admin_log` VALUES (36, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:44:51', '2023-10-08 15:44:51');
INSERT INTO `admin_log` VALUES (37, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 15:45:34', '2023-10-08 15:45:34');
INSERT INTO `admin_log` VALUES (38, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:45:34', '2023-10-08 15:45:34');
INSERT INTO `admin_log` VALUES (39, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 15:45:44', '2023-10-08 15:45:44');
INSERT INTO `admin_log` VALUES (40, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 15:45:44', '2023-10-08 15:45:44');
INSERT INTO `admin_log` VALUES (41, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:23', '2023-10-08 16:37:23');
INSERT INTO `admin_log` VALUES (42, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:24', '2023-10-08 16:37:24');
INSERT INTO `admin_log` VALUES (43, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:42', '2023-10-08 16:37:42');
INSERT INTO `admin_log` VALUES (44, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:43', '2023-10-08 16:37:43');
INSERT INTO `admin_log` VALUES (45, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:43', '2023-10-08 16:37:43');
INSERT INTO `admin_log` VALUES (46, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:37:43', '2023-10-08 16:37:43');
INSERT INTO `admin_log` VALUES (47, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:38:27', '2023-10-08 16:38:27');
INSERT INTO `admin_log` VALUES (48, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:38:28', '2023-10-08 16:38:28');
INSERT INTO `admin_log` VALUES (49, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:38:28', '2023-10-08 16:38:28');
INSERT INTO `admin_log` VALUES (50, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:33', '2023-10-08 16:39:33');
INSERT INTO `admin_log` VALUES (51, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:35', '2023-10-08 16:39:35');
INSERT INTO `admin_log` VALUES (52, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:50', '2023-10-08 16:39:50');
INSERT INTO `admin_log` VALUES (53, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:50', '2023-10-08 16:39:50');
INSERT INTO `admin_log` VALUES (54, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:52', '2023-10-08 16:39:52');
INSERT INTO `admin_log` VALUES (55, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:39:52', '2023-10-08 16:39:52');
INSERT INTO `admin_log` VALUES (56, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:40:13', '2023-10-08 16:40:13');
INSERT INTO `admin_log` VALUES (57, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:40:14', '2023-10-08 16:40:14');
INSERT INTO `admin_log` VALUES (58, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:40:15', '2023-10-08 16:40:15');
INSERT INTO `admin_log` VALUES (59, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:40:15', '2023-10-08 16:40:15');
INSERT INTO `admin_log` VALUES (60, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:41:15', '2023-10-08 16:41:15');
INSERT INTO `admin_log` VALUES (61, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:41:15', '2023-10-08 16:41:15');
INSERT INTO `admin_log` VALUES (62, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:41:17', '2023-10-08 16:41:17');
INSERT INTO `admin_log` VALUES (63, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:42:12', '2023-10-08 16:42:12');
INSERT INTO `admin_log` VALUES (64, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:42:13', '2023-10-08 16:42:13');
INSERT INTO `admin_log` VALUES (65, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:49', '2023-10-08 16:43:49');
INSERT INTO `admin_log` VALUES (66, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:49', '2023-10-08 16:43:49');
INSERT INTO `admin_log` VALUES (67, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:51', '2023-10-08 16:43:51');
INSERT INTO `admin_log` VALUES (68, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:52', '2023-10-08 16:43:52');
INSERT INTO `admin_log` VALUES (69, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:57', '2023-10-08 16:43:57');
INSERT INTO `admin_log` VALUES (70, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:43:58', '2023-10-08 16:43:58');
INSERT INTO `admin_log` VALUES (71, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:44:29', '2023-10-08 16:44:29');
INSERT INTO `admin_log` VALUES (72, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:44:52', '2023-10-08 16:44:52');
INSERT INTO `admin_log` VALUES (73, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:46:23', '2023-10-08 16:46:23');
INSERT INTO `admin_log` VALUES (74, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:14', '2023-10-08 16:48:14');
INSERT INTO `admin_log` VALUES (75, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:14', '2023-10-08 16:48:14');
INSERT INTO `admin_log` VALUES (76, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:15', '2023-10-08 16:48:15');
INSERT INTO `admin_log` VALUES (77, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:16', '2023-10-08 16:48:16');
INSERT INTO `admin_log` VALUES (78, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:53', '2023-10-08 16:48:53');
INSERT INTO `admin_log` VALUES (79, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:48:54', '2023-10-08 16:48:54');
INSERT INTO `admin_log` VALUES (80, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-08 16:49:33', '2023-10-08 16:49:33');
INSERT INTO `admin_log` VALUES (81, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:27:33', '2023-10-09 11:27:33');
INSERT INTO `admin_log` VALUES (82, 1, 'admin/nav/navedit', 'GET', '127.0.0.1', '[]', '2023-10-09 11:27:35', '2023-10-09 11:27:35');
INSERT INTO `admin_log` VALUES (83, 1, 'admin/nav/navedit', 'POST', '127.0.0.1', '{\"nav_name\":\"python\\u6280\\u80fd\\u63d0\\u5347\\u73ed\",\"_nav_price%22\":\"5199\",\"original_price\":\"5699\",\"is_show\":\"0\",\"nav_sort\":\"0\"}', '2023-10-09 11:28:16', '2023-10-09 11:28:16');
INSERT INTO `admin_log` VALUES (84, 1, 'admin/nav/navedit', 'GET', '127.0.0.1', '[]', '2023-10-09 11:28:39', '2023-10-09 11:28:39');
INSERT INTO `admin_log` VALUES (85, 1, 'admin/nav/navedit', 'POST', '127.0.0.1', '{\"nav_name\":\"Python\\u6280\\u80fd\\u63d0\\u5347\\u73ed\",\"nav_price\":\"5199\",\"original_price\":\"5699\",\"is_show\":\"0\",\"nav_sort\":\"0\"}', '2023-10-09 11:29:08', '2023-10-09 11:29:08');
INSERT INTO `admin_log` VALUES (86, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:09', '2023-10-09 11:29:09');
INSERT INTO `admin_log` VALUES (87, 1, 'admin/nav/navedit/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:29:11', '2023-10-09 11:29:11');
INSERT INTO `admin_log` VALUES (88, 1, 'admin/nav/navedit/nav_id/1', 'POST', '127.0.0.1', '{\"nav_name\":\"Python\\u6280\\u80fd\\u63d0\\u5347\\u73ed1\",\"nav_price\":\"5199\",\"original_price\":\"5699.00\",\"is_show\":\"0\",\"nav_sort\":\"0\",\"nav_id\":\"1\"}', '2023-10-09 11:29:14', '2023-10-09 11:29:14');
INSERT INTO `admin_log` VALUES (89, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:15', '2023-10-09 11:29:15');
INSERT INTO `admin_log` VALUES (90, 1, 'admin/nav/navedit/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:29:16', '2023-10-09 11:29:16');
INSERT INTO `admin_log` VALUES (91, 1, 'admin/nav/navedit/nav_id/1', 'POST', '127.0.0.1', '{\"nav_name\":\"Python\\u6280\\u80fd\\u63d0\\u5347\\u73ed\",\"nav_price\":\"5199\",\"original_price\":\"5699.00\",\"is_show\":\"0\",\"nav_sort\":\"0\",\"nav_id\":\"1\"}', '2023-10-09 11:29:18', '2023-10-09 11:29:18');
INSERT INTO `admin_log` VALUES (92, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:19', '2023-10-09 11:29:19');
INSERT INTO `admin_log` VALUES (93, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"is_course\":\"no\"}', '2023-10-09 11:29:28', '2023-10-09 11:29:28');
INSERT INTO `admin_log` VALUES (94, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:45', '2023-10-09 11:29:45');
INSERT INTO `admin_log` VALUES (95, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:45', '2023-10-09 11:29:45');
INSERT INTO `admin_log` VALUES (96, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:46', '2023-10-09 11:29:46');
INSERT INTO `admin_log` VALUES (97, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:49', '2023-10-09 11:29:49');
INSERT INTO `admin_log` VALUES (98, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:49', '2023-10-09 11:29:49');
INSERT INTO `admin_log` VALUES (99, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:29:50', '2023-10-09 11:29:50');
INSERT INTO `admin_log` VALUES (100, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:30:19', '2023-10-09 11:30:19');
INSERT INTO `admin_log` VALUES (101, 1, 'admin/type/typeedit', 'GET', '127.0.0.1', '[]', '2023-10-09 11:30:22', '2023-10-09 11:30:22');
INSERT INTO `admin_log` VALUES (102, 1, 'admin/type/typeedit', 'POST', '127.0.0.1', '{\"type_name\":\"Python\\u57fa\\u7840\\u8bfe\\u7a0b\",\"nav_id\":\"1\",\"is_free\":\"0\",\"is_show\":\"1\",\"type_desc\":\"\\u672c\\u9636\\u6bb5\\u662f\\u8fdb\\u5165\\u201c\\u7a0b\\u5e8f\\u5458\\u201d\\u7684\\u95e8\\u69db\\uff0c\\u9700\\u8981\\u5b66\\u4e60\\u7f16\\u7a0b\\u57fa\\u672c\\u7684\\u77e5\\u8bc6\\u3002\\u672c\\u9636\\u6bb5\\u4f1a\\u4ece0\\u5f00\\u59cb\\uff0c\\u5faa\\u5e8f\\u6e10\\u8fdb\\u3002\\u8ba9\\u5c0f\\u4f19\\u4f34\\u4eec\\u8ba4\\u771f\\u5b66\\u5b8c\\u672c\\u9636\\u6bb5\\uff0c\\u5c31\\u4f1a\\u638c\\u63e1\\uff1a\\u53d8\\u91cf\\u3001\\u6570\\u636e\\u7c7b\\u578b\\u3001\\u63a7\\u5236\\u8bed\\u53e5\\u3001\\u5bb9\\u5668\\u3001\\u51fd\\u6570\\u548c\\u9762\\u5411\\u5bf9\\u8c61\\u7b49\\u3002\\u6559\\u7a0b\\u4e2d\\u4f1a\\u7a7f\\u63d2\\u4e00\\u4e9b\\u6709\\u8da3\\u7684\\u6848\\u4f8b\\uff0c\\u5bd3\\u6559\\u4e8e\\u4e50\\uff0c\\u5f15\\u8d77\\u5927\\u5bb6\\u7684\\u5174\\u8da3\\u3002\",\"type_sort\":\"0\",\"type_id\":\"\"}', '2023-10-09 11:30:57', '2023-10-09 11:30:57');
INSERT INTO `admin_log` VALUES (103, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:30:58', '2023-10-09 11:30:58');
INSERT INTO `admin_log` VALUES (104, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:31:22', '2023-10-09 11:31:22');
INSERT INTO `admin_log` VALUES (105, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:31:39', '2023-10-09 11:31:39');
INSERT INTO `admin_log` VALUES (106, 1, 'admin/type/typeedit/type_id/1', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 11:31:41', '2023-10-09 11:31:41');
INSERT INTO `admin_log` VALUES (107, 1, 'admin/type/typeedit', 'POST', '127.0.0.1', '{\"type_name\":\"Python\\u57fa\\u7840\\u8bfe\\u7a0b1\",\"nav_id\":\"1\",\"is_free\":\"0\",\"is_show\":\"1\",\"type_desc\":\"\\u672c\\u9636\\u6bb5\\u662f\\u8fdb\\u5165\\u201c\\u7a0b\\u5e8f\\u5458\\u201d\\u7684\\u95e8\\u69db\\uff0c\\u9700\\u8981\\u5b66\\u4e60\\u7f16\\u7a0b\\u57fa\\u672c\\u7684\\u77e5\\u8bc6\\u3002\\u672c\\u9636\\u6bb5\\u4f1a\\u4ece0\\u5f00\\u59cb\\uff0c\\u5faa\\u5e8f\\u6e10\\u8fdb\\u3002\\u8ba9\\u5c0f\\u4f19\\u4f34\\u4eec\\u8ba4\\u771f\\u5b66\\u5b8c\\u672c\\u9636\\u6bb5\\uff0c\\u5c31\\u4f1a\\u638c\\u63e1\\uff1a\\u53d8\\u91cf\\u3001\\u6570\\u636e\\u7c7b\\u578b\\u3001\\u63a7\\u5236\\u8bed\\u53e5\\u3001\\u5bb9\\u5668\\u3001\\u51fd\\u6570\\u548c\\u9762\\u5411\\u5bf9\\u8c61\\u7b49\\u3002\\u6559\\u7a0b\\u4e2d\\u4f1a\\u7a7f\\u63d2\\u4e00\\u4e9b\\u6709\\u8da3\\u7684\\u6848\\u4f8b\\uff0c\\u5bd3\\u6559\\u4e8e\\u4e50\\uff0c\\u5f15\\u8d77\\u5927\\u5bb6\\u7684\\u5174\\u8da3\\u3002\",\"type_sort\":\"0\",\"type_id\":\"1\"}', '2023-10-09 11:31:46', '2023-10-09 11:31:46');
INSERT INTO `admin_log` VALUES (108, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:31:47', '2023-10-09 11:31:47');
INSERT INTO `admin_log` VALUES (109, 1, 'admin/type/typeedit/type_id/1', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 11:31:48', '2023-10-09 11:31:48');
INSERT INTO `admin_log` VALUES (110, 1, 'admin/type/typeedit', 'POST', '127.0.0.1', '{\"type_name\":\"Python\\u57fa\\u7840\\u8bfe\\u7a0b\",\"nav_id\":\"1\",\"is_free\":\"0\",\"is_show\":\"1\",\"type_desc\":\"\\u672c\\u9636\\u6bb5\\u662f\\u8fdb\\u5165\\u201c\\u7a0b\\u5e8f\\u5458\\u201d\\u7684\\u95e8\\u69db\\uff0c\\u9700\\u8981\\u5b66\\u4e60\\u7f16\\u7a0b\\u57fa\\u672c\\u7684\\u77e5\\u8bc6\\u3002\\u672c\\u9636\\u6bb5\\u4f1a\\u4ece0\\u5f00\\u59cb\\uff0c\\u5faa\\u5e8f\\u6e10\\u8fdb\\u3002\\u8ba9\\u5c0f\\u4f19\\u4f34\\u4eec\\u8ba4\\u771f\\u5b66\\u5b8c\\u672c\\u9636\\u6bb5\\uff0c\\u5c31\\u4f1a\\u638c\\u63e1\\uff1a\\u53d8\\u91cf\\u3001\\u6570\\u636e\\u7c7b\\u578b\\u3001\\u63a7\\u5236\\u8bed\\u53e5\\u3001\\u5bb9\\u5668\\u3001\\u51fd\\u6570\\u548c\\u9762\\u5411\\u5bf9\\u8c61\\u7b49\\u3002\\u6559\\u7a0b\\u4e2d\\u4f1a\\u7a7f\\u63d2\\u4e00\\u4e9b\\u6709\\u8da3\\u7684\\u6848\\u4f8b\\uff0c\\u5bd3\\u6559\\u4e8e\\u4e50\\uff0c\\u5f15\\u8d77\\u5927\\u5bb6\\u7684\\u5174\\u8da3\\u3002\",\"type_sort\":\"0\",\"type_id\":\"1\"}', '2023-10-09 11:31:51', '2023-10-09 11:31:51');
INSERT INTO `admin_log` VALUES (111, 1, 'admin/type/index', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 11:31:52', '2023-10-09 11:31:52');
INSERT INTO `admin_log` VALUES (112, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:33:00', '2023-10-09 11:33:00');
INSERT INTO `admin_log` VALUES (113, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:33:01', '2023-10-09 11:33:01');
INSERT INTO `admin_log` VALUES (114, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 11:33:01', '2023-10-09 11:33:01');
INSERT INTO `admin_log` VALUES (115, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:32', '2023-10-09 14:12:32');
INSERT INTO `admin_log` VALUES (116, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:33', '2023-10-09 14:12:33');
INSERT INTO `admin_log` VALUES (117, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:46', '2023-10-09 14:12:46');
INSERT INTO `admin_log` VALUES (118, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:47', '2023-10-09 14:12:47');
INSERT INTO `admin_log` VALUES (119, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:48', '2023-10-09 14:12:48');
INSERT INTO `admin_log` VALUES (120, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:49', '2023-10-09 14:12:49');
INSERT INTO `admin_log` VALUES (121, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:49', '2023-10-09 14:12:49');
INSERT INTO `admin_log` VALUES (122, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:12:49', '2023-10-09 14:12:49');
INSERT INTO `admin_log` VALUES (123, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:07', '2023-10-09 14:13:07');
INSERT INTO `admin_log` VALUES (124, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:07', '2023-10-09 14:13:07');
INSERT INTO `admin_log` VALUES (125, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:08', '2023-10-09 14:13:08');
INSERT INTO `admin_log` VALUES (126, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:08', '2023-10-09 14:13:08');
INSERT INTO `admin_log` VALUES (127, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:08', '2023-10-09 14:13:08');
INSERT INTO `admin_log` VALUES (128, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:25', '2023-10-09 14:13:25');
INSERT INTO `admin_log` VALUES (129, 1, 'admin/specific/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:30', '2023-10-09 14:13:30');
INSERT INTO `admin_log` VALUES (130, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:58', '2023-10-09 14:13:58');
INSERT INTO `admin_log` VALUES (131, 1, 'admin/specific/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 14:13:59', '2023-10-09 14:13:59');
INSERT INTO `admin_log` VALUES (132, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:14:01', '2023-10-09 14:14:01');
INSERT INTO `admin_log` VALUES (133, 1, 'admin/specific/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 14:14:03', '2023-10-09 14:14:03');
INSERT INTO `admin_log` VALUES (134, 1, 'admin/specific/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 14:14:17', '2023-10-09 14:14:17');
INSERT INTO `admin_log` VALUES (135, 1, 'admin/specific/edit', 'POST', '127.0.0.1', '{\"s_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"s_show\":\"1\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_sort\":\"0\"}', '2023-10-09 14:15:12', '2023-10-09 14:15:12');
INSERT INTO `admin_log` VALUES (136, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-09 14:16:57', '2023-10-09 14:16:57');
INSERT INTO `admin_log` VALUES (137, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-09 14:16:57', '2023-10-09 14:16:57');
INSERT INTO `admin_log` VALUES (138, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:16:59', '2023-10-09 14:16:59');
INSERT INTO `admin_log` VALUES (139, 1, 'admin/specific/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 14:17:00', '2023-10-09 14:17:00');
INSERT INTO `admin_log` VALUES (140, 1, 'admin/specific/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 14:17:05', '2023-10-09 14:17:05');
INSERT INTO `admin_log` VALUES (141, 1, 'admin/specific/edit', 'POST', '127.0.0.1', '{\"s_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"s_show\":\"1\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_sort\":\"0\"}', '2023-10-09 14:17:07', '2023-10-09 14:17:07');
INSERT INTO `admin_log` VALUES (142, 1, 'admin/specific/index/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 14:17:09', '2023-10-09 14:17:09');
INSERT INTO `admin_log` VALUES (143, 1, 'admin/specific/index/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 14:19:57', '2023-10-09 14:19:57');
INSERT INTO `admin_log` VALUES (144, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:20:39', '2023-10-09 14:20:39');
INSERT INTO `admin_log` VALUES (145, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:21:05', '2023-10-09 14:21:05');
INSERT INTO `admin_log` VALUES (146, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:21:06', '2023-10-09 14:21:06');
INSERT INTO `admin_log` VALUES (147, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:21:07', '2023-10-09 14:21:07');
INSERT INTO `admin_log` VALUES (148, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:23:29', '2023-10-09 14:23:29');
INSERT INTO `admin_log` VALUES (149, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:23:45', '2023-10-09 14:23:45');
INSERT INTO `admin_log` VALUES (150, 1, 'admin/training/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:24:13', '2023-10-09 14:24:13');
INSERT INTO `admin_log` VALUES (151, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 14:24:22', '2023-10-09 14:24:22');
INSERT INTO `admin_log` VALUES (152, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 14:26:41', '2023-10-09 14:26:41');
INSERT INTO `admin_log` VALUES (153, 1, 'admin/course/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 14:26:54', '2023-10-09 14:26:54');
INSERT INTO `admin_log` VALUES (154, 1, 'admin/course/gets', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 14:26:56', '2023-10-09 14:26:56');
INSERT INTO `admin_log` VALUES (155, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-09 15:21:32', '2023-10-09 15:21:32');
INSERT INTO `admin_log` VALUES (156, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-09 15:21:32', '2023-10-09 15:21:32');
INSERT INTO `admin_log` VALUES (157, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 15:21:34', '2023-10-09 15:21:34');
INSERT INTO `admin_log` VALUES (158, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-09 15:21:37', '2023-10-09 15:21:37');
INSERT INTO `admin_log` VALUES (159, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:21:40', '2023-10-09 15:21:40');
INSERT INTO `admin_log` VALUES (160, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:24:41', '2023-10-09 15:24:41');
INSERT INTO `admin_log` VALUES (161, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:25:29', '2023-10-09 15:25:29');
INSERT INTO `admin_log` VALUES (162, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:25:50', '2023-10-09 15:25:50');
INSERT INTO `admin_log` VALUES (163, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:25:55', '2023-10-09 15:25:55');
INSERT INTO `admin_log` VALUES (164, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:26:22', '2023-10-09 15:26:22');
INSERT INTO `admin_log` VALUES (165, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:26:53', '2023-10-09 15:26:53');
INSERT INTO `admin_log` VALUES (166, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:27:45', '2023-10-09 15:27:45');
INSERT INTO `admin_log` VALUES (167, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:27:51', '2023-10-09 15:27:51');
INSERT INTO `admin_log` VALUES (168, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:28:27', '2023-10-09 15:28:27');
INSERT INTO `admin_log` VALUES (169, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:28:51', '2023-10-09 15:28:51');
INSERT INTO `admin_log` VALUES (170, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:28:52', '2023-10-09 15:28:52');
INSERT INTO `admin_log` VALUES (171, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:29:32', '2023-10-09 15:29:32');
INSERT INTO `admin_log` VALUES (172, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:38:15', '2023-10-09 15:38:15');
INSERT INTO `admin_log` VALUES (173, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:51:05', '2023-10-09 15:51:05');
INSERT INTO `admin_log` VALUES (174, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:51:24', '2023-10-09 15:51:24');
INSERT INTO `admin_log` VALUES (175, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:52:18', '2023-10-09 15:52:18');
INSERT INTO `admin_log` VALUES (176, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 15:53:04', '2023-10-09 15:53:04');
INSERT INTO `admin_log` VALUES (177, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 16:41:28', '2023-10-09 16:41:28');
INSERT INTO `admin_log` VALUES (178, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:02:54', '2023-10-09 17:02:54');
INSERT INTO `admin_log` VALUES (179, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:03:02', '2023-10-09 17:03:02');
INSERT INTO `admin_log` VALUES (180, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:03:23', '2023-10-09 17:03:23');
INSERT INTO `admin_log` VALUES (181, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:03:59', '2023-10-09 17:03:59');
INSERT INTO `admin_log` VALUES (182, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:05:37', '2023-10-09 17:05:37');
INSERT INTO `admin_log` VALUES (183, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:05:56', '2023-10-09 17:05:56');
INSERT INTO `admin_log` VALUES (184, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:06:14', '2023-10-09 17:06:14');
INSERT INTO `admin_log` VALUES (185, 1, 'admin/course/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 17:07:58', '2023-10-09 17:07:58');
INSERT INTO `admin_log` VALUES (186, 1, 'admin/course/gets', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 17:08:12', '2023-10-09 17:08:12');
INSERT INTO `admin_log` VALUES (187, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"1\",\"free\":\"0\",\"is_must\":\"0\",\"ccid\":\"1\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_sort\":\"0\",\"course_id\":\"\"}', '2023-10-09 17:08:14', '2023-10-09 17:08:14');
INSERT INTO `admin_log` VALUES (188, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:08:45', '2023-10-09 17:08:45');
INSERT INTO `admin_log` VALUES (189, 1, 'admin/course/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 17:08:51', '2023-10-09 17:08:51');
INSERT INTO `admin_log` VALUES (190, 1, 'admin/course/gets', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 17:08:53', '2023-10-09 17:08:53');
INSERT INTO `admin_log` VALUES (191, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"1\",\"is_free\":\"0\",\"is_must\":\"0\",\"ccid\":\"1\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_sort\":\"0\",\"course_id\":\"\"}', '2023-10-09 17:08:55', '2023-10-09 17:08:55');
INSERT INTO `admin_log` VALUES (192, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-09 17:09:09', '2023-10-09 17:09:09');
INSERT INTO `admin_log` VALUES (193, 1, 'admin/course/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-09 17:09:15', '2023-10-09 17:09:15');
INSERT INTO `admin_log` VALUES (194, 1, 'admin/course/gets', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-09 17:09:16', '2023-10-09 17:09:16');
INSERT INTO `admin_log` VALUES (195, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"1\",\"is_free\":\"0\",\"is_must\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_sort\":\"0\",\"course_id\":\"\"}', '2023-10-09 17:09:18', '2023-10-09 17:09:18');
INSERT INTO `admin_log` VALUES (196, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"1\",\"is_free\":\"0\",\"is_must\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_sort\":\"0\",\"course_id\":\"\"}', '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `admin_log` VALUES (197, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:09:42', '2023-10-09 17:09:42');
INSERT INTO `admin_log` VALUES (198, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:10:02', '2023-10-09 17:10:02');
INSERT INTO `admin_log` VALUES (199, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:10:04', '2023-10-09 17:10:04');
INSERT INTO `admin_log` VALUES (200, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:10:43', '2023-10-09 17:10:43');
INSERT INTO `admin_log` VALUES (201, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:13:11', '2023-10-09 17:13:11');
INSERT INTO `admin_log` VALUES (202, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:13:46', '2023-10-09 17:13:46');
INSERT INTO `admin_log` VALUES (203, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:14:17', '2023-10-09 17:14:17');
INSERT INTO `admin_log` VALUES (204, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:15:05', '2023-10-09 17:15:05');
INSERT INTO `admin_log` VALUES (205, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:15:25', '2023-10-09 17:15:25');
INSERT INTO `admin_log` VALUES (206, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-09 17:15:36', '2023-10-09 17:15:36');
INSERT INTO `admin_log` VALUES (207, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"is_show\":\"yes\",\"keywords\":\"\",\"vid\":\"\",\"course_sort\":{\"1\":\"0\"}}', '2023-10-09 17:15:43', '2023-10-09 17:15:43');
INSERT INTO `admin_log` VALUES (208, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"keywords\":\"\",\"vid\":\"\"}', '2023-10-09 17:15:44', '2023-10-09 17:15:44');
INSERT INTO `admin_log` VALUES (209, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"is_show\":\"yes\",\"keywords\":\"\",\"vid\":\"\",\"course_sort\":{\"1\":\"0\"}}', '2023-10-09 17:15:45', '2023-10-09 17:15:45');
INSERT INTO `admin_log` VALUES (210, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"keywords\":\"\",\"vid\":\"\"}', '2023-10-09 17:15:45', '2023-10-09 17:15:45');
INSERT INTO `admin_log` VALUES (211, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"is_show\":\"yes\",\"keywords\":\"\",\"vid\":\"\",\"course_sort\":{\"1\":\"0\"}}', '2023-10-09 17:15:46', '2023-10-09 17:15:46');
INSERT INTO `admin_log` VALUES (212, 1, 'admin/course/index', 'POST', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"keywords\":\"\",\"vid\":\"\"}', '2023-10-09 17:15:47', '2023-10-09 17:15:47');
INSERT INTO `admin_log` VALUES (213, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-10 15:38:04', '2023-10-10 15:38:04');
INSERT INTO `admin_log` VALUES (214, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-10 15:38:04', '2023-10-10 15:38:04');
INSERT INTO `admin_log` VALUES (215, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-10 15:38:12', '2023-10-10 15:38:12');
INSERT INTO `admin_log` VALUES (216, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-10 15:38:19', '2023-10-10 15:38:19');
INSERT INTO `admin_log` VALUES (217, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:38:33', '2023-10-10 15:38:33');
INSERT INTO `admin_log` VALUES (218, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:40:22', '2023-10-10 15:40:22');
INSERT INTO `admin_log` VALUES (219, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:40:22', '2023-10-10 15:40:22');
INSERT INTO `admin_log` VALUES (220, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:40:54', '2023-10-10 15:40:54');
INSERT INTO `admin_log` VALUES (221, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:40:55', '2023-10-10 15:40:55');
INSERT INTO `admin_log` VALUES (222, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:41:13', '2023-10-10 15:41:13');
INSERT INTO `admin_log` VALUES (223, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-10 15:41:44', '2023-10-10 15:41:44');
INSERT INTO `admin_log` VALUES (224, 1, 'admin/nav/navedit/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-10 15:41:46', '2023-10-10 15:41:46');
INSERT INTO `admin_log` VALUES (225, 1, 'admin/nav/navedit/nav_id/1', 'POST', '127.0.0.1', '{\"nav_name\":\"Python\\u6280\\u80fd\\u63d0\\u5347\\u73ed\",\"nav_price\":\"5199\",\"original_price\":\"5699.00\",\"is_show\":\"1\",\"nav_sort\":\"0\",\"nav_id\":\"1\"}', '2023-10-10 15:41:48', '2023-10-10 15:41:48');
INSERT INTO `admin_log` VALUES (226, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-10 15:41:49', '2023-10-10 15:41:49');
INSERT INTO `admin_log` VALUES (227, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:41:50', '2023-10-10 15:41:50');
INSERT INTO `admin_log` VALUES (228, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:41:56', '2023-10-10 15:41:56');
INSERT INTO `admin_log` VALUES (229, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:42:42', '2023-10-10 15:42:42');
INSERT INTO `admin_log` VALUES (230, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:42:45', '2023-10-10 15:42:45');
INSERT INTO `admin_log` VALUES (231, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:43:11', '2023-10-10 15:43:11');
INSERT INTO `admin_log` VALUES (232, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:43:13', '2023-10-10 15:43:13');
INSERT INTO `admin_log` VALUES (233, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:43:15', '2023-10-10 15:43:15');
INSERT INTO `admin_log` VALUES (234, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-10 15:43:29', '2023-10-10 15:43:29');
INSERT INTO `admin_log` VALUES (235, 1, 'admin/specific/edit/s_id/1', 'GET', '127.0.0.1', '{\"s_id\":\"1\"}', '2023-10-10 15:43:32', '2023-10-10 15:43:32');
INSERT INTO `admin_log` VALUES (236, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 15:43:38', '2023-10-10 15:43:38');
INSERT INTO `admin_log` VALUES (237, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:46:58', '2023-10-10 15:46:58');
INSERT INTO `admin_log` VALUES (238, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:47:00', '2023-10-10 15:47:00');
INSERT INTO `admin_log` VALUES (239, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:47:39', '2023-10-10 15:47:39');
INSERT INTO `admin_log` VALUES (240, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:47:41', '2023-10-10 15:47:41');
INSERT INTO `admin_log` VALUES (241, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_id\":\"1\",\"stem\":\"\"}', '2023-10-10 15:47:43', '2023-10-10 15:47:43');
INSERT INTO `admin_log` VALUES (242, 1, 'admin/sub/question', 'POST', '127.0.0.1', '{\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"course_id\":\"\",\"stem\":\"\"}', '2023-10-10 15:47:45', '2023-10-10 15:47:45');
INSERT INTO `admin_log` VALUES (243, 1, 'admin/sub/ques_edit', 'GET', '127.0.0.1', '[]', '2023-10-10 15:47:48', '2023-10-10 15:47:48');
INSERT INTO `admin_log` VALUES (244, 1, 'admin/sub/ques_edit', 'GET', '127.0.0.1', '[]', '2023-10-10 15:49:34', '2023-10-10 15:49:34');
INSERT INTO `admin_log` VALUES (245, 1, 'admin/sub/getType', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-10 15:49:41', '2023-10-10 15:49:41');
INSERT INTO `admin_log` VALUES (246, 1, 'admin/sub/getS', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-10 15:49:43', '2023-10-10 15:49:43');
INSERT INTO `admin_log` VALUES (247, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-10 15:58:09', '2023-10-10 15:58:09');
INSERT INTO `admin_log` VALUES (248, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-10 16:27:24', '2023-10-10 16:27:24');
INSERT INTO `admin_log` VALUES (249, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:32', '2023-10-10 16:28:32');
INSERT INTO `admin_log` VALUES (250, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:34', '2023-10-10 16:28:34');
INSERT INTO `admin_log` VALUES (251, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:54', '2023-10-10 16:28:54');
INSERT INTO `admin_log` VALUES (252, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:55', '2023-10-10 16:28:55');
INSERT INTO `admin_log` VALUES (253, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:57', '2023-10-10 16:28:57');
INSERT INTO `admin_log` VALUES (254, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-10 16:28:58', '2023-10-10 16:28:58');
INSERT INTO `admin_log` VALUES (255, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-10 16:29:13', '2023-10-10 16:29:13');
INSERT INTO `admin_log` VALUES (256, 1, 'admin/sub/question', 'GET', '127.0.0.1', '{\"page\":\"2\"}', '2023-10-10 16:29:21', '2023-10-10 16:29:21');
INSERT INTO `admin_log` VALUES (257, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-11 10:21:39', '2023-10-11 10:21:39');
INSERT INTO `admin_log` VALUES (258, 1, 'admin/sub/ques_edit/id/30', 'GET', '127.0.0.1', '{\"id\":\"30\"}', '2023-10-11 10:21:41', '2023-10-11 10:21:41');
INSERT INTO `admin_log` VALUES (259, 1, 'admin/sub/ques_edit/id/30', 'GET', '127.0.0.1', '{\"id\":\"30\"}', '2023-10-11 10:22:23', '2023-10-11 10:22:23');
INSERT INTO `admin_log` VALUES (260, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-11 10:23:11', '2023-10-11 10:23:11');
INSERT INTO `admin_log` VALUES (261, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-11 10:25:49', '2023-10-11 10:25:49');
INSERT INTO `admin_log` VALUES (262, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-11 10:25:55', '2023-10-11 10:25:55');
INSERT INTO `admin_log` VALUES (263, 1, 'admin/sub/ques_edit/id/30', 'GET', '127.0.0.1', '{\"id\":\"30\"}', '2023-10-11 10:25:57', '2023-10-11 10:25:57');
INSERT INTO `admin_log` VALUES (264, 1, 'admin', 'GET', '127.0.0.1', '[]', '2023-10-11 10:28:05', '2023-10-11 10:28:05');
INSERT INTO `admin_log` VALUES (265, 1, 'admin/sub/ques_edit/id/30', 'GET', '127.0.0.1', '{\"id\":\"30\"}', '2023-10-11 10:30:09', '2023-10-11 10:30:09');
INSERT INTO `admin_log` VALUES (266, 1, 'admin/sub/uploads', 'POST', '127.0.0.1', '{\"guid\":\"1696991412028\"}', '2023-10-11 10:30:15', '2023-10-11 10:30:15');
INSERT INTO `admin_log` VALUES (267, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-11 10:31:11', '2023-10-11 10:31:11');
INSERT INTO `admin_log` VALUES (268, 1, 'admin/type/typeedit/type_id/1', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-11 10:33:01', '2023-10-11 10:33:01');
INSERT INTO `admin_log` VALUES (269, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:03', '2023-10-17 12:45:03');
INSERT INTO `admin_log` VALUES (270, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:03', '2023-10-17 12:45:03');
INSERT INTO `admin_log` VALUES (271, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:07', '2023-10-17 12:45:07');
INSERT INTO `admin_log` VALUES (272, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:08', '2023-10-17 12:45:08');
INSERT INTO `admin_log` VALUES (273, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:09', '2023-10-17 12:45:09');
INSERT INTO `admin_log` VALUES (274, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:10', '2023-10-17 12:45:10');
INSERT INTO `admin_log` VALUES (275, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:14', '2023-10-17 12:45:14');
INSERT INTO `admin_log` VALUES (276, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"page\":\"2\"}', '2023-10-17 12:45:25', '2023-10-17 12:45:25');
INSERT INTO `admin_log` VALUES (277, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:45:40', '2023-10-17 12:45:40');
INSERT INTO `admin_log` VALUES (278, 1, 'admin/nav/navedit/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-17 12:45:41', '2023-10-17 12:45:41');
INSERT INTO `admin_log` VALUES (279, 1, 'admin/nav/navedit/nav_id/1', 'POST', '127.0.0.1', '{\"nav_name\":\"Python\\u6280\\u80fd\\u63d0\\u5347\\u73ed\",\"nav_price\":\"5199\",\"original_price\":\"5699.00\",\"nav_icon\":\"python1\",\"is_show\":\"1\",\"nav_sort\":\"0\",\"nav_id\":\"1\"}', '2023-10-17 12:46:01', '2023-10-17 12:46:01');
INSERT INTO `admin_log` VALUES (280, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:46:02', '2023-10-17 12:46:02');
INSERT INTO `admin_log` VALUES (281, 1, 'admin/nav/navedit/nav_id/1', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-17 12:46:03', '2023-10-17 12:46:03');
INSERT INTO `admin_log` VALUES (282, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-17 12:52:45', '2023-10-17 12:52:45');
INSERT INTO `admin_log` VALUES (283, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-17 12:52:48', '2023-10-17 12:52:48');
INSERT INTO `admin_log` VALUES (284, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-17 12:52:59', '2023-10-17 12:52:59');
INSERT INTO `admin_log` VALUES (285, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-17 12:53:42', '2023-10-17 12:53:42');
INSERT INTO `admin_log` VALUES (286, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-17 13:10:00', '2023-10-17 13:10:00');
INSERT INTO `admin_log` VALUES (287, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:10:01', '2023-10-17 13:10:01');
INSERT INTO `admin_log` VALUES (288, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-17 13:10:07', '2023-10-17 13:10:07');
INSERT INTO `admin_log` VALUES (289, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:10:12', '2023-10-17 13:10:12');
INSERT INTO `admin_log` VALUES (290, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-17 13:10:20', '2023-10-17 13:10:20');
INSERT INTO `admin_log` VALUES (291, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:10:22', '2023-10-17 13:10:22');
INSERT INTO `admin_log` VALUES (292, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-17 13:11:07', '2023-10-17 13:11:07');
INSERT INTO `admin_log` VALUES (293, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:11:11', '2023-10-17 13:11:11');
INSERT INTO `admin_log` VALUES (294, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:11:21', '2023-10-17 13:11:21');
INSERT INTO `admin_log` VALUES (295, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-17 13:11:25', '2023-10-17 13:11:25');
INSERT INTO `admin_log` VALUES (296, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:11:29', '2023-10-17 13:11:29');
INSERT INTO `admin_log` VALUES (297, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-17 13:13:55', '2023-10-17 13:13:55');
INSERT INTO `admin_log` VALUES (298, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:35:09', '2023-10-19 16:35:09');
INSERT INTO `admin_log` VALUES (299, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:35:09', '2023-10-19 16:35:09');
INSERT INTO `admin_log` VALUES (300, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:35:40', '2023-10-19 16:35:40');
INSERT INTO `admin_log` VALUES (301, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:37:37', '2023-10-19 16:37:37');
INSERT INTO `admin_log` VALUES (302, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-19 16:37:37', '2023-10-19 16:37:37');
INSERT INTO `admin_log` VALUES (303, 1, 'admin/type/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:37:40', '2023-10-19 16:37:40');
INSERT INTO `admin_log` VALUES (304, 1, 'admin/specific/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:37:41', '2023-10-19 16:37:41');
INSERT INTO `admin_log` VALUES (305, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:37:41', '2023-10-19 16:37:41');
INSERT INTO `admin_log` VALUES (306, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-19 16:37:44', '2023-10-19 16:37:44');
INSERT INTO `admin_log` VALUES (307, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-19 16:39:19', '2023-10-19 16:39:19');
INSERT INTO `admin_log` VALUES (308, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-19 16:39:52', '2023-10-19 16:39:52');
INSERT INTO `admin_log` VALUES (309, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"2\",\"is_free\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\",\"course_id\":\"1\"}', '2023-10-19 16:39:59', '2023-10-19 16:39:59');
INSERT INTO `admin_log` VALUES (310, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"2\",\"is_free\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\",\"course_id\":\"1\"}', '2023-10-19 16:40:50', '2023-10-19 16:40:50');
INSERT INTO `admin_log` VALUES (311, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-19 16:41:37', '2023-10-19 16:41:37');
INSERT INTO `admin_log` VALUES (312, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"2\",\"is_free\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\"}', '2023-10-19 16:41:47', '2023-10-19 16:41:47');
INSERT INTO `admin_log` VALUES (313, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-19 16:41:48', '2023-10-19 16:41:48');
INSERT INTO `admin_log` VALUES (314, 1, 'admin/course/edit/id/1', 'GET', '127.0.0.1', '{\"id\":\"1\"}', '2023-10-19 16:41:50', '2023-10-19 16:41:50');
INSERT INTO `admin_log` VALUES (315, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:42:01', '2023-10-19 16:42:01');
INSERT INTO `admin_log` VALUES (316, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"2\",\"is_free\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\"}', '2023-10-19 16:42:45', '2023-10-19 16:42:45');
INSERT INTO `admin_log` VALUES (317, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:43:02', '2023-10-19 16:43:02');
INSERT INTO `admin_log` VALUES (318, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:45:57', '2023-10-19 16:45:57');
INSERT INTO `admin_log` VALUES (319, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:45:58', '2023-10-19 16:45:58');
INSERT INTO `admin_log` VALUES (320, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:46:22', '2023-10-19 16:46:22');
INSERT INTO `admin_log` VALUES (321, 1, 'admin/course/edit/id/37', 'POST', '127.0.0.1', '{\"course_name\":\"Python\\u662f\\u4ec0\\u4e48\",\"type\":\"2\",\"is_free\":\"0\",\"vid\":\"64901470c4911135cb1863a139e41934_6\",\"document\":\"<p>1111111<\\/p>\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\",\"id\":\"37\"}', '2023-10-19 16:46:30', '2023-10-19 16:46:30');
INSERT INTO `admin_log` VALUES (322, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-19 16:46:31', '2023-10-19 16:46:31');
INSERT INTO `admin_log` VALUES (323, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:46:33', '2023-10-19 16:46:33');
INSERT INTO `admin_log` VALUES (324, 1, 'admin/course/edit/id/37', 'GET', '127.0.0.1', '{\"id\":\"37\"}', '2023-10-19 16:47:05', '2023-10-19 16:47:05');
INSERT INTO `admin_log` VALUES (325, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:47:48', '2023-10-19 16:47:48');
INSERT INTO `admin_log` VALUES (326, 1, 'admin/privilege/delete/privilege_id/100', 'GET', '127.0.0.1', '{\"privilege_id\":\"100\"}', '2023-10-19 16:47:54', '2023-10-19 16:47:54');
INSERT INTO `admin_log` VALUES (327, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:47:55', '2023-10-19 16:47:55');
INSERT INTO `admin_log` VALUES (328, 1, 'admin/privilege/delete/privilege_id/113', 'GET', '127.0.0.1', '{\"privilege_id\":\"113\"}', '2023-10-19 16:47:58', '2023-10-19 16:47:58');
INSERT INTO `admin_log` VALUES (329, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:47:59', '2023-10-19 16:47:59');
INSERT INTO `admin_log` VALUES (330, 1, 'admin/privilege/delete/privilege_id/125', 'GET', '127.0.0.1', '{\"privilege_id\":\"125\"}', '2023-10-19 16:48:03', '2023-10-19 16:48:03');
INSERT INTO `admin_log` VALUES (331, 1, 'admin/privilege/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:05', '2023-10-19 16:48:05');
INSERT INTO `admin_log` VALUES (332, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:05', '2023-10-19 16:48:05');
INSERT INTO `admin_log` VALUES (333, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:05', '2023-10-19 16:48:05');
INSERT INTO `admin_log` VALUES (334, 1, 'admin/sub/question', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:06', '2023-10-19 16:48:06');
INSERT INTO `admin_log` VALUES (335, 1, 'admin/nav/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:09', '2023-10-19 16:48:09');
INSERT INTO `admin_log` VALUES (336, 1, 'admin/course/index', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:11', '2023-10-19 16:48:11');
INSERT INTO `admin_log` VALUES (337, 1, 'admin/course/edit', 'GET', '127.0.0.1', '[]', '2023-10-19 16:48:13', '2023-10-19 16:48:13');
INSERT INTO `admin_log` VALUES (338, 1, 'admin/course/gettype', 'GET', '127.0.0.1', '{\"nav_id\":\"1\"}', '2023-10-19 16:48:25', '2023-10-19 16:48:25');
INSERT INTO `admin_log` VALUES (339, 1, 'admin/course/gets', 'GET', '127.0.0.1', '{\"type_id\":\"1\"}', '2023-10-19 16:48:27', '2023-10-19 16:48:27');
INSERT INTO `admin_log` VALUES (340, 1, 'admin/course/edit', 'POST', '127.0.0.1', '{\"course_name\":\"\\u7ec3\\u4e60\\uff1aPython\\u662f\\u4ec0\\u4e48\",\"type\":\"3\",\"is_free\":\"0\",\"vid\":\"\",\"document\":\"\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"0\",\"course_sort\":\"0\"}', '2023-10-19 16:48:29', '2023-10-19 16:48:29');
INSERT INTO `admin_log` VALUES (341, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-19 16:48:30', '2023-10-19 16:48:30');
INSERT INTO `admin_log` VALUES (342, 1, 'admin/course/edit/id/38', 'GET', '127.0.0.1', '{\"id\":\"38\"}', '2023-10-19 16:48:38', '2023-10-19 16:48:38');
INSERT INTO `admin_log` VALUES (343, 1, 'admin/course/edit/id/38', 'POST', '127.0.0.1', '{\"course_name\":\"\\u7ec3\\u4e60\\uff1aPython\\u662f\\u4ec0\\u4e48\",\"type\":\"3\",\"is_free\":\"0\",\"vid\":\"\",\"document\":\"\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\",\"points\":\"1\",\"is_show\":\"1\",\"course_sort\":\"0\",\"id\":\"38\"}', '2023-10-19 16:48:41', '2023-10-19 16:48:41');
INSERT INTO `admin_log` VALUES (344, 1, 'admin/course/index', 'GET', '127.0.0.1', '{\"status\":\"select\",\"nav_id\":\"1\",\"type_id\":\"1\",\"s_id\":\"1\"}', '2023-10-19 16:48:42', '2023-10-19 16:48:42');
INSERT INTO `admin_log` VALUES (345, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:06', '2023-10-24 14:14:06');
INSERT INTO `admin_log` VALUES (346, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:07', '2023-10-24 14:14:07');
INSERT INTO `admin_log` VALUES (347, 1, 'admin/index/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:26', '2023-10-24 14:14:26');
INSERT INTO `admin_log` VALUES (348, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:26', '2023-10-24 14:14:26');
INSERT INTO `admin_log` VALUES (349, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:28', '2023-10-24 14:14:28');
INSERT INTO `admin_log` VALUES (350, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:14:40', '2023-10-24 14:14:40');
INSERT INTO `admin_log` VALUES (351, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:16:05', '2023-10-24 14:16:05');
INSERT INTO `admin_log` VALUES (352, 1, 'admin/user/index', 'GET', '127.0.0.1', '[]', '2023-10-24 14:16:49', '2023-10-24 14:16:49');
INSERT INTO `admin_log` VALUES (353, 1, 'admin/index/info', 'GET', '127.0.0.1', '[]', '2023-10-24 16:52:40', '2023-10-24 16:52:40');
COMMIT;

-- ----------------------------
-- Table structure for admin_training
-- ----------------------------
DROP TABLE IF EXISTS `admin_training`;
CREATE TABLE `admin_training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `kut_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '学生给老师评分状态 2是好评 1是中评 3是差评 0是未评分',
  `t_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `time` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rds_idx_2` (`kut_id`,`admin_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_name` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `class_desc` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `class_time` varchar(255) NOT NULL,
  `nav_id` int(11) NOT NULL,
  `typeId` int(11) DEFAULT NULL COMMENT '班型',
  `open_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for class_nav
-- ----------------------------
DROP TABLE IF EXISTS `class_nav`;
CREATE TABLE `class_nav` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `shorter` varchar(255) NOT NULL,
  `money` int(11) NOT NULL,
  `intro` mediumtext COMMENT '介绍',
  `action` tinyint(1) NOT NULL DEFAULT '1',
  `background` varchar(255) DEFAULT NULL COMMENT '背景图',
  `created_admin_id` int(11) NOT NULL,
  `updated_admin_id` int(11) NOT NULL,
  `created_time` int(10) NOT NULL,
  `updated_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for class_nav_type
-- ----------------------------
DROP TABLE IF EXISTS `class_nav_type`;
CREATE TABLE `class_nav_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL,
  `nav_id` int(11) NOT NULL,
  `type_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for class_nav_user
-- ----------------------------
DROP TABLE IF EXISTS `class_nav_user`;
CREATE TABLE `class_nav_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `created_admin_id` int(11) NOT NULL,
  `updated_admin_id` int(11) NOT NULL,
  `created_time` int(10) NOT NULL,
  `updated_time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `course_id` int(11) NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `course_sort` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表视频 2代表挑战 3代表练习 4代表文档',
  `vid` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `video_time` int(200) DEFAULT NULL,
  `video_size` varchar(50) DEFAULT NULL,
  `document` text,
  `nav_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `s_id` int(11) DEFAULT NULL,
  `is_free` int(1) NOT NULL DEFAULT '0' COMMENT '是否是试听 0是不免费 1是免费',
  `points` int(11) NOT NULL DEFAULT '1' COMMENT '掌握点',
  `visits` int(10) NOT NULL DEFAULT '0',
  `is_show` tinyint(1) NOT NULL DEFAULT '1',
  `created_admin_id` int(11) NOT NULL DEFAULT '1',
  `updated_admin_id` int(11) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`course_id`),
  KEY `index_name` (`type_id`,`nav_id`,`s_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
INSERT INTO `course` VALUES (1, 'Python是什么', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (2, 'Python是什么1', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (3, 'Python是什么2', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (4, 'Python是什么3', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (5, 'Python是什么4', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (6, 'Python是什么5', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 2, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (7, 'Python是什么6', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 2, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (8, 'Python是什么7', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 2, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (9, 'Python是什么8', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 3, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (10, 'Python是什么9', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 3, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (11, 'Python是什么10', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 1, 3, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (12, 'Python是什么11', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 5, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (13, 'Python是什么12', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 5, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (14, 'Python是什么13', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 5, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (15, 'Python是什么14', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 6, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (16, 'Python是什么15', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 6, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (17, 'Python是什么16', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 6, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (18, 'Python是什么17', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 7, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (19, 'Python是什么18', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 7, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (20, 'Python是什么19', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 7, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (21, 'Python是什么20', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 2, 7, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (22, 'Python是什么21', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 8, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (23, 'Python是什么22', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 8, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (24, 'Python是什么23', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 8, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (25, 'Python是什么24', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 8, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (26, 'Python是什么25', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (27, 'Python是什么26', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (28, 'Python是什么27', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (29, 'Python是什么28', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (30, 'Python是什么29', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (31, 'Python是什么30', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 9, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (32, 'Python是什么31', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 10, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (33, 'Python是什么32', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 10, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (34, 'Python是什么33', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 10, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (35, 'Python是什么34', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 10, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (36, 'Python是什么35', 0, 1, '64901470c4911135cb1863a139e41934_6', 500, NULL, NULL, 1, 3, 10, 0, 1, 0, 1, 1, 1, '2023-10-09 17:09:41', '2023-10-09 17:09:41');
INSERT INTO `course` VALUES (37, 'Python是什么', 0, 2, '64901470c4911135cb1863a139e41934_6', NULL, NULL, '<p>1111111</p>', 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-19 16:41:47', '2023-10-19 16:46:30');
INSERT INTO `course` VALUES (38, '练习：Python是什么', 0, 3, '', NULL, NULL, '', 1, 1, 1, 0, 1, 0, 1, 1, 1, '2023-10-19 16:48:29', '2023-10-19 16:48:41');
COMMIT;

-- ----------------------------
-- Table structure for know_user
-- ----------------------------
DROP TABLE IF EXISTS `know_user`;
CREATE TABLE `know_user` (
  `know_user_id` varchar(100) NOT NULL,
  `know_phone` varchar(44) DEFAULT NULL,
  `know_email` varchar(44) DEFAULT NULL,
  `know_password` varchar(32) DEFAULT NULL,
  `know_avatar` varchar(255) DEFAULT 'https://www.itbaizhan.cn/public/images/person.jpeg',
  `know_sex` varchar(10) DEFAULT NULL,
  `salt` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `userid` varchar(100) DEFAULT '0',
  `register_time` datetime NOT NULL,
  `register_ip` varchar(255) NOT NULL,
  `login_time` datetime DEFAULT NULL,
  `login_ip` varchar(255) DEFAULT NULL,
  `login_num` int(11) NOT NULL DEFAULT '1',
  `action` int(11) DEFAULT '0' COMMENT '0是电脑端 1是手机端 2是微信小程序端 3是APP',
  `token` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `money` int(11) NOT NULL DEFAULT '0',
  `locking` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1代表正常上学 0代表用户锁定（休学中）',
  `expired_time` datetime DEFAULT NULL,
  PRIMARY KEY (`know_user_id`),
  UNIQUE KEY `contact` (`know_phone`,`know_email`) USING BTREE,
  KEY `idx_knowphone` (`know_phone`) USING BTREE,
  KEY `idx_knowemail` (`know_email`) USING BTREE,
  KEY `index_name_id` (`know_user_id`,`userid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of know_user
-- ----------------------------
BEGIN;
INSERT INTO `know_user` VALUES ('97caaf5ca038bd9be6b5443cbe046671', 'ZJ5skmZua2pmnJM=', NULL, '5ad73b6b280cacd2ffc168ca56e6c47e', 'https://www.itbaizhan.cn/public/images/person.jpeg', NULL, 'd37W9m', '0', '2023-10-24 13:34:17', '127.0.0.1', '2023-10-24 13:52:11', '127.0.0.1', 2, 0, '7B0CCB7279B2FEE75A90B55C34B30699', 0, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for know_user_log
-- ----------------------------
DROP TABLE IF EXISTS `know_user_log`;
CREATE TABLE `know_user_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) NOT NULL,
  `course_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1表示已完成 0表示未完成',
  `points` int(11) NOT NULL,
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  PRIMARY KEY (`id`,`user_id`),
  KEY `idx_userid_time` (`user_id`,`updated_time`) USING BTREE,
  KEY `rds_idx_0` (`course_id`,`user_id`,`updated_time`,`points`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for know_user_nav
-- ----------------------------
DROP TABLE IF EXISTS `know_user_nav`;
CREATE TABLE `know_user_nav` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `orderid` int(11) DEFAULT NULL,
  `money` int(255) DEFAULT NULL,
  `from` varchar(11) DEFAULT NULL,
  `study_num` int(11) DEFAULT NULL,
  `coupon` int(5) NOT NULL DEFAULT '0',
  `classType` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `spread` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '推广老师',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '缴费备注',
  `valid` varchar(5) NOT NULL DEFAULT 'yes',
  `expire_time` datetime DEFAULT NULL,
  `type_id` varchar(255) DEFAULT NULL,
  `s_id` varchar(255) DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `spread_id` int(11) DEFAULT NULL,
  `is_see` varchar(5) NOT NULL DEFAULT 'yes',
  `update_time` datetime DEFAULT NULL,
  `vip_id` int(11) NOT NULL COMMENT '0',
  `expired_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_name` (`user_id`) USING BTREE,
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for know_user_question
-- ----------------------------
DROP TABLE IF EXISTS `know_user_question`;
CREATE TABLE `know_user_question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `course_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `content` longtext NOT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `answer` int(1) NOT NULL DEFAULT '0' COMMENT '是否已回答  0是未回答 1是已回答 ',
  `is_tuijian` int(1) NOT NULL DEFAULT '0' COMMENT '是否推荐（0是不推荐 1是推荐）',
  `admin_id` int(11) DEFAULT NULL,
  `reply_status` varchar(5) NOT NULL DEFAULT 'yes',
  `updated_admin_id` int(11) DEFAULT NULL,
  `updated_time` int(11) DEFAULT NULL,
  `is_negative` varchar(5) NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  KEY `idx_userid_typeid` (`user_id`,`course_id`,`pid`,`admin_id`,`updated_admin_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for know_user_record
-- ----------------------------
DROP TABLE IF EXISTS `know_user_record`;
CREATE TABLE `know_user_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) NOT NULL,
  `course_id` int(11) NOT NULL,
  `record` float(10,5) NOT NULL,
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for know_user_third
-- ----------------------------
DROP TABLE IF EXISTS `know_user_third`;
CREATE TABLE `know_user_third` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'wechat',
  `openid` varchar(255) NOT NULL,
  `nickname` varchar(255) NOT NULL,
  `start_time` int(10) NOT NULL,
  `last_time` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for know_user_training
-- ----------------------------
DROP TABLE IF EXISTS `know_user_training`;
CREATE TABLE `know_user_training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `type_id` int(11) NOT NULL,
  `s_id` int(11) NOT NULL,
  `t_id` int(11) NOT NULL,
  `time` varchar(11) NOT NULL,
  `content` longtext NOT NULL,
  `grade` int(1) NOT NULL DEFAULT '0' COMMENT '评分状态 0是未评分 1是及格 2是不及格 3是优秀',
  `score` int(3) NOT NULL DEFAULT '0',
  `is_tuijian` int(1) NOT NULL DEFAULT '0' COMMENT '是否推荐（0是不推荐 1是推荐）',
  `is_free` int(1) NOT NULL DEFAULT '0' COMMENT '是否是试听 0是不免费 1是免费',
  `is_edit` varchar(10) NOT NULL DEFAULT 'editor',
  `is_negative` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_userid_typeid_tid` (`user_id`,`type_id`,`t_id`,`time`,`score`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for know_user_type
-- ----------------------------
DROP TABLE IF EXISTS `know_user_type`;
CREATE TABLE `know_user_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `type_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '阶段是否看完 1是已完成 0是未完成',
  `created_time` datetime NOT NULL,
  `updated_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for nav
-- ----------------------------
DROP TABLE IF EXISTS `nav`;
CREATE TABLE `nav` (
  `nav_id` int(11) NOT NULL AUTO_INCREMENT,
  `nav_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `nav_icon` varchar(255) DEFAULT NULL,
  `nav_price` decimal(10,0) NOT NULL DEFAULT '0',
  `original_price` decimal(10,2) NOT NULL,
  `nav_sort` int(11) NOT NULL,
  `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1是展示 0是不展示',
  PRIMARY KEY (`nav_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of nav
-- ----------------------------
BEGIN;
INSERT INTO `nav` VALUES (1, 'Python技能提升班', 'python1', 5199, 5699.00, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for phone_num
-- ----------------------------
DROP TABLE IF EXISTS `phone_num`;
CREATE TABLE `phone_num` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) NOT NULL,
  `num` char(6) NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3750134 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of phone_num
-- ----------------------------
BEGIN;
INSERT INTO `phone_num` VALUES (3750133, '18500774590', '751453', '2023-10-24 13:49:44');
COMMIT;

-- ----------------------------
-- Table structure for privilege
-- ----------------------------
DROP TABLE IF EXISTS `privilege`;
CREATE TABLE `privilege` (
  `privilege_id` int(10) NOT NULL AUTO_INCREMENT,
  `privilege_name` varchar(50) NOT NULL COMMENT '权限名称',
  `controller_name` varchar(50) NOT NULL COMMENT '控制器名',
  `action_name` varchar(50) NOT NULL COMMENT '方法名',
  `parent_id` int(10) NOT NULL DEFAULT '0',
  `privilege_status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`privilege_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of privilege
-- ----------------------------
BEGIN;
INSERT INTO `privilege` VALUES (1, '内容管理', 'content', 'index', 0, 1);
INSERT INTO `privilege` VALUES (6, '专业', 'nav', 'index', 1, 1);
INSERT INTO `privilege` VALUES (13, '阶段', 'type', 'index', 1, 1);
INSERT INTO `privilege` VALUES (14, '章节', 'specific', 'index', 1, 1);
INSERT INTO `privilege` VALUES (19, '课程', 'course', 'index', 1, 1);
INSERT INTO `privilege` VALUES (22, '管理员设置', 'admin', 'index', 0, 1);
INSERT INTO `privilege` VALUES (23, '管理员管理', 'admin', 'index', 22, 1);
INSERT INTO `privilege` VALUES (27, '角色管理', 'role', 'index', 22, 1);
INSERT INTO `privilege` VALUES (31, '权限管理', 'privilege', 'index', 22, 1);
INSERT INTO `privilege` VALUES (35, '基本设置', 'admin', 'index', 0, 1);
INSERT INTO `privilege` VALUES (36, '修改密码', 'admin', 'pass', 35, 1);
INSERT INTO `privilege` VALUES (45, '用户中心', 'user', 'index', 0, 1);
INSERT INTO `privilege` VALUES (46, '用户中心', 'user', 'index', 45, 1);
INSERT INTO `privilege` VALUES (48, '订单管理', 'order', 'index', 45, 1);
INSERT INTO `privilege` VALUES (104, '邀请码', 'admin', 'rands', 35, 1);
INSERT INTO `privilege` VALUES (105, '问答点评', 'user', 'question', 45, 1);
INSERT INTO `privilege` VALUES (106, '实操点评', 'training', 'lists', 45, 1);
INSERT INTO `privilege` VALUES (108, '班级管理', 'classes', 'index', 0, 1);
INSERT INTO `privilege` VALUES (109, '班级管理', 'classes', 'index', 108, 1);
INSERT INTO `privilege` VALUES (114, '学生管理', 'classes', 'student', 108, 1);
INSERT INTO `privilege` VALUES (141, '问答列表', 'other', 'question', 45, 1);
INSERT INTO `privilege` VALUES (147, '题库管理', 'sub', 'question', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` int(10) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) NOT NULL COMMENT '角色名称',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `role_privilege`;
CREATE TABLE `role_privilege` (
  `role_id` int(10) NOT NULL,
  `privilege_id` int(10) NOT NULL,
  PRIMARY KEY (`role_id`,`privilege_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for specific
-- ----------------------------
DROP TABLE IF EXISTS `specific`;
CREATE TABLE `specific` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_name` varchar(255) NOT NULL,
  `nav_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `s_sort` int(255) NOT NULL,
  `s_show` tinyint(1) NOT NULL DEFAULT '1',
  `updated_admin_id` int(11) NOT NULL DEFAULT '1',
  `updated_time` datetime NOT NULL,
  `created_admin_id` int(11) NOT NULL,
  `created_time` datetime NOT NULL,
  PRIMARY KEY (`s_id`),
  KEY `ind_tb1a` (`s_sort`) USING BTREE,
  KEY `index_name` (`type_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of specific
-- ----------------------------
BEGIN;
INSERT INTO `specific` VALUES (1, 'Python是什么', 1, 1, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (2, 'Python是什么1', 1, 1, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (3, 'Python是什么2', 1, 1, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (4, 'Python是什么3', 1, 1, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (5, 'Python是什么4', 1, 2, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (6, 'Python是什么5', 1, 2, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (7, 'Python是什么6', 1, 2, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (8, 'Python是什么7', 1, 3, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (9, 'Python是什么8', 1, 3, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
INSERT INTO `specific` VALUES (10, 'Python是什么9', 1, 3, 0, 1, 1, '2023-10-09 14:17:07', 1, '2023-10-09 14:17:07');
COMMIT;

-- ----------------------------
-- Table structure for sub_question
-- ----------------------------
DROP TABLE IF EXISTS `sub_question`;
CREATE TABLE `sub_question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1表示单选',
  `nav_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `s_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `seek` int(11) NOT NULL DEFAULT '0',
  `stem` text NOT NULL,
  `metas` text NOT NULL COMMENT '题目元信息',
  `answer` text NOT NULL,
  `points` int(11) NOT NULL DEFAULT '1' COMMENT '掌握点',
  `visits` int(11) NOT NULL DEFAULT '0' COMMENT '做题次数',
  `created_admin_id` int(11) NOT NULL,
  `created_time` int(10) NOT NULL,
  `updated_admin_id` int(11) NOT NULL,
  `updated_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sub_question
-- ----------------------------
BEGIN;
INSERT INTO `sub_question` VALUES (1, 1, 1, 1, 1, 1, 430, 'python的发明人是:', '{\"choices\":[\"\\u9a6c\\u65af\\u514b\",\"\\u8a79\\u59c6\\u65af\\u00b7\\u9ad8\\u65af\\u6797\",\"\\u4e39\\u5c3c\\u65af\\u00b7\\u91cc\\u5947\",\"\\u5409\\u591a\\u00b7\\u8303\\u7f57\\u82cf\\u59c6\\uff08\\u9f9f\\u53d4\\uff09\"]}', '[\"3\"]', 1, 518, 1, 1643247821, 1, 1643254982);
INSERT INTO `sub_question` VALUES (2, 1, 1, 1, 1, 1, 430, '如下关于python的说法错误的是:', '{\"choices\":[\"python\\u662f\\u89e3\\u91ca\\u6027\\u8bed\\u8a00\",\"python3\\u53ef\\u4ee5\\u517c\\u5bb9python2\",\"python\\u5728\\u4eba\\u5de5\\u667a\\u80fd\\u9886\\u57df\\u5e94\\u7528\\u5e7f\\u6cdb\",\"python\\u5728\\u6e38\\u620f\\u5f00\\u53d1\\u9886\\u57df\\u5e94\\u7528\\u5e7f\\u6cdb\"]}', '[\"1\"]', 1, 543, 1, 1643248204, 1, 1643248227);
INSERT INTO `sub_question` VALUES (3, 1, 1, 1, 1, 1, 790, '初学者碰到某个知识点听两三次课都学不懂，如下哪种方式是正确的？', '{\"choices\":[\"\\u6b7b\\u78d5\\u5b83\\uff0c\\u6211\\u4e00\\u5b9a\\u8981100%\\u638c\\u63e1\\u5b83\",\"\\u5f88\\u6b63\\u5e38\\uff0c\\u4e0d\\u614c\\u5f20\\uff0c\\u8bb0\\u4f4f\\u7ed3\\u8bba\\uff0c\\u7ee7\\u7eed\\u5f80\\u540e\\u5b66\\u3002\\u4e00\\u4e2a\\u6708\\u540e\\uff0c\\u56de\\u6765\\u770b\\u3002\",\"\\u614c\\u4e86\\uff0c\\u6000\\u7591\\u4eba\\u751f\\uff0c\\u6000\\u7591\\u81ea\\u5df1\",\"\\u89c9\\u5f97\\u81ea\\u5df1\\u4e0d\\u9002\\u5408\\u5b66\\u4e60\"]}', '[\"1\"]', 1, 489, 1, 1643253633, 1, 1643254679);
INSERT INTO `sub_question` VALUES (4, 1, 1, 1, 1, 1, 790, '\"守破离\"学习战略思想，说法错误的是？', '{\"choices\":[\"\\u5b66\\u4e60\\u671f\\u95f4\\uff0c\\u7167\\u7740\\u8001\\u5e08\\u7684\\u505a\\u3002\\u4e0d\\u6025\\u529f\\u8fd1\\u5229\\uff0c\\u4e0d\\u505a\\u521b\\u65b0\\uff01\\u4e0d\\u6000\\u7591\\u8001\\u5e08\\uff01\",\"\\u5b88\\u7684\\u9636\\u6bb5\\uff0c\\u5929\\u5929\\u6000\\u7591\\u8001\\u5e08\\uff0c\\u60f3\\u7740\\u521b\\u51fa\\u81ea\\u5df1\\u7684\\u8def\\uff0c\\u592a\\u6025\\u8e81\",\"\\u7834\\u7684\\u9636\\u6bb5\\uff0c\\u5de5\\u4f5c\\u540e\\uff0c\\u5f00\\u59cb\\u7a81\\u7834\\uff0c\\u6000\\u7591\\u8001\\u5e08\\uff01\\u81ea\\u5df1\\u5f00\\u59cb\\u6784\\u5efa\\u81ea\\u5df1\\u7684\\u77e5\\u8bc6\\u4f53\\u7cfb\",\"\\u79bb\\u7684\\u9636\\u6bb5\\uff0c\\u5de5\\u4f5c3\\u5e74\\u540e\\uff0c\\u5f62\\u6210\\u81ea\\u8eab\\u4f53\\u7cfb\\uff0c\\u5f7b\\u5e95\\u8131\\u79bb\\u8001\\u5e08\\uff0c\\u81ea\\u6210\\u4e00\\u5bb6\\uff01\"]}', '[\"1\"]', 1, 516, 1, 1643254344, 1, 1643254630);
INSERT INTO `sub_question` VALUES (5, 1, 1, 1, 1, 1, 430, '要让python在windows命令行中使用，需要做什么操作？', '{\"choices\":[\" \\u9ed8\\u8ba4\\u5b89\\u88c5\\u540e\\uff0c\\u5c31\\u80fd\\u968f\\u610f\\u4f7f\\u7528\\uff0c\\u4ec0\\u4e48\\u64cd\\u4f5c\\u90fd\\u4e0d\\u7528\\u505a\",\"\\u5b89\\u88c5\\u65f6\\uff0c\\u9009\\u4e2dAdd Python 3.10 to path \\u590d\\u9009\\u6846\",\"\\u5c06python\\u5b89\\u88c5\\u5230c\\u76d8\\u5373\\u53ef\",\"\\u5c06python\\u5b89\\u88c5\\u5728c:\\/windows\\u76ee\\u5f55\\u4e0b\"]}', '[\"1\"]', 1, 482, 1, 1643262704, 1, 1643262704);
INSERT INTO `sub_question` VALUES (6, 1, 1, 1, 1, 1, 430, '如下python代码，会打印什么结果？\r\n```python\r\nprint(\"hello world\")\r\n```', '{\"choices\":[\"\\u7f3a\\u5c11\\u5206\\u53f7\\uff0c\\u62a5\\u9519\",\" \\u7f3a\\u5c11\\u9017\\u53f7\\uff0c\\u62a5\\u9519\",\"\\u53ef\\u4ee5\\u6b63\\u5e38\\u6267\\u884c\\uff0c\\u6253\\u5370\\u8f93\\u51fa\\\"hello world\\\"\",\"\\u53ef\\u4ee5\\u6b63\\u5e38\\u6267\\u884c\\uff0c\\u6253\\u5370\\u8f93\\u51fahello world\"]}', '[\"3\"]', 1, 532, 1, 1643262791, 1, 1643266933);
INSERT INTO `sub_question` VALUES (8, 1, 1, 1, 1, 1, 610, '如下哪个不是python开发环境？', '{\"choices\":[\"pycharm\",\"IDEA\",\"vscode\",\"jupyter\"]}', '[\"1\"]', 1, 583, 1, 1643264230, 1, 1643264230);
INSERT INTO `sub_question` VALUES (9, 1, 1, 1, 1, 1, 370, '如下关于python程序的基本格式，错误的说法是：', '{\"choices\":[\"Python\\u4e0d\\u533a\\u5206\\u5927\\u5c0f\\u5199\",\"Python\\u7528\\u7f29\\u8fdb\\u800c\\u4e0d\\u662f{}\\u8868\\u793a\\u7a0b\\u5e8f\\u5757\\u7684\\u5c42\\u6b21\\u5173\\u7cfb\",\"\\u5355\\u884c\\u6ce8\\u91ca\\u662f#\\u5f00\\u5934\",\"\\u591a\\u884c\\u6ce8\\u91ca\\uff1a\\u4f7f\\u7528\\u4e09\\u4e2a\\u8fde\\u7eed\\u5355\\u5f15\\u53f7\'\'\'\\u6216\\u4e09\\u4e2a\\u53cc\\u5f15\\u53f7\\\"\\\"\\\"\"]}', '[\"0\"]', 1, 521, 1, 1643264343, 1, 1643264343);
INSERT INTO `sub_question` VALUES (10, 1, 1, 1, 1, 1, 250, ' 初学者碰到错误，如下哪种方式是错误的？', '{\"choices\":[\"\\u78b0\\u5230\\u9519\\u8bef\\uff0c\\u5f00\\u5fc3\\uff01\\u60f3\\u60f3\\u529e\\u6cd5\\uff0c\\u641e\\u5b9a\\u4ed6\",\"\\u7ec6\\u5fc3\\u770b\\u9519\\u8bef\\u63d0\\u793a\\uff0c\\u662f\\u54ea\\u4e00\\u884c\\u3002\\u770b\\u8fd9\\u4e00\\u884c\\u548c\\u8001\\u5e08\\u4ee3\\u7801\\u6709\\u4ec0\\u4e48\\u533a\\u522b\",\"\\u628a\\u5173\\u952e\\u4fe1\\u606f\\u653e\\u5230\\u767e\\u5ea6\\u4e2d\\u770b\\u770b\\u522b\\u4eba\\u600e\\u4e48\\u5904\\u7406\",\"\\u78b0\\u5230\\u9519\\u8bef\\uff0c\\u662f\\u6211\\u4eba\\u4e0d\\u884c\\uff01\\u6211\\u5e9f\\u4e86\\uff0c\\u6211\\u9a6c\\u4e0a\\u627e\\u8001\\u5e08\\u89e3\\u51b3\"]}', '[\"3\"]', 1, 499, 1, 1643264463, 1, 1643264463);
INSERT INTO `sub_question` VALUES (11, 1, 1, 1, 1, 1, 550, '关于海龟绘图模块的使用，错误的说法是：', '{\"choices\":[\"turtle.goto(60,-50)\\u662f\\u5c06\\u753b\\u7b14\\u7684\\u4f4d\\u7f6e\\u79fb\\u52a8\\u5230\\u5750\\u6807\\uff1a(60, -50)\",\"turtle.done() \\u7684\\u4f5c\\u7528\\u7a0b\\u5e8f\\u7ed3\\u675f\\uff0c\\u7a97\\u53e3\\u4ecd\\u7136\\u4fdd\\u6301\",\"turtle.color(\\\"blue\\\")\\u662f\\u5c06\\u753b\\u7b14\\u8bbe\\u7f6e\\u6210\\u84dd\\u8272\",\"\\u53ef\\u4ee5\\u76f4\\u63a5\\u4f7f\\u7528\\uff0c\\u4e0d\\u9700\\u8981\\u5bfc\\u5165\\u6a21\\u5757: import turtle\"]}', '[\"3\"]', 1, 503, 1, 1643264598, 1, 1643269269);
INSERT INTO `sub_question` VALUES (12, 1, 1, 1, 1, 1, 380, '关于python代码组织，正确的说法是:', '{\"choices\":[\"python\\u4e2d\\uff0c\\u4e5f\\u53ef\\u4ee5\\u50cfc\\u8bed\\u8a00\\u4e00\\u6837\\u4f7f\\u7528{ }\\u8868\\u793a\\u7f29\\u8fdb\",\"python\\u4e2d\\uff0c\\u5f3a\\u5236\\u4f7f\\u7528\\u7f29\\u8fdb\\uff0c\\u4e00\\u822c4\\u4e2a\\u7a7a\\u683c\\u8868\\u793a\\u4e00\\u4e2a\\u7f29\\u8fdb\",\"python\\u4e2d\\uff0c\\u7f29\\u8fdb\\u662f\\u53ef\\u9009\\u7684\\uff0c\\u4e0d\\u5f3a\\u5236\",\"python\\u4e2d\\uff0c\\u89e3\\u91ca\\u5668\\u4f1a\\u81ea\\u52a8\\u52a0\\u7f29\\u8fdb\\uff0c\\u7f29\\u8fdb\\u4e0d\\u5f3a\\u5236\\u5199\\u4e5f\\u53ef\\u4ee5\"]}', '[\"1\"]', 1, 531, 1, 1643267963, 1, 1643267963);
INSERT INTO `sub_question` VALUES (13, 1, 1, 1, 1, 1, 380, ' 一行代码较长，变成多行，使用什么符号？', '{\"choices\":[\"\\u56de\\u8f66\\u7b26\",\"\\/ \\u884c\\u8fde\\u63a5\\u7b26\",\"\\\\ \\u884c\\u8fde\\u63a5\\u7b26\",\"\\u4f7f\\u7528\\u5206\\u53f7\"]}', '[\"2\"]', 1, 539, 1, 1643268049, 1, 1643268049);
INSERT INTO `sub_question` VALUES (14, 1, 1, 1, 1, 1, 430, '对象由三部分组成，是哪三部分:', '{\"choices\":[\"int\\uff0ctype\\uff0cvalue\",\"int, class, value\",\"class, type, value\",\"id, type, value\"]}', '[\"3\"]', 1, 519, 1, 1643268148, 1, 1643268148);
INSERT INTO `sub_question` VALUES (15, 1, 1, 1, 1, 1, 490, '如下关于异常机制本质，说法正确的是：', '{\"choices\":[\"\\u5f53\\u7a0b\\u5e8f\\u51fa\\u73b0\\u5f02\\u5e38\\uff0c\\u7a0b\\u5e8f\\u5f7b\\u5e95\\u9000\\u51fa\",\"\\u5f53\\u7a0b\\u5e8f\\u51fa\\u73b0\\u5f02\\u5e38\\uff0c\\u7a0b\\u5e8f\\u51fa\\u73b0\\u4e0d\\u53ef\\u77e5\\u7684\\u7ed3\\u679c\",\"\\u5f53\\u7a0b\\u5e8f\\u51fa\\u73b0\\u5f02\\u5e38\\uff0c\\u7a0b\\u5e8f\\u5b89\\u5168\\u7684\\u9000\\u51fa\\u3001\\u5904\\u7406\\u5b8c\\u540e\\u7ee7\\u7eed\\u6267\\u884c\\u7684\\u673a\\u5236\",\"\\u5f53\\u7a0b\\u5e8f\\u51fa\\u73b0\\u5f02\\u5e38\\uff0c\\u7a0b\\u5e8f\\u968f\\u673a\\u7ec8\\u6b62\\u5230\\u67d0\\u884c\\u4ee3\\u7801\"]}', '[\"2\"]', 1, 333, 1, 1643268370, 1, 1643269020);
INSERT INTO `sub_question` VALUES (16, 1, 1, 1, 1, 1, 610, '碰到异常，错误的态度是：', '{\"choices\":[\"\\u4e0d\\u614c\\u5f20\\uff0c\\u7ec6\\u770b\\u4fe1\\u606f\\uff0c\\u5b9a\\u4f4d\\u9519\\u8bef\\u3002\",\"\\u767e\\u5ea6\\u5e76\\u67e5\\u770b\\u5341\\u4e2a\\u76f8\\u5173\\u5e16\\u5b50\\u3002\",\"\\u767e\\u5ea6\\u65e0\\u6cd5\\u89e3\\u51b3\\uff0c\\u95ee\\u8001\\u5e08\",\"\\u614c\\u5f20\\uff0c\\u6211\\u80fd\\u529b\\u4e0d\\u884c\\uff0c\\u6211\\u9519\\u4e86\\u3002\\u9a6c\\u4e0a\\u8ba9\\u8001\\u5e08\\u5e2e\\u5fd9\\u8c03\\u9519\"]}', '[\"3\"]', 1, 301, 1, 1643268506, 1, 1643269300);
INSERT INTO `sub_question` VALUES (17, 1, 1, 1, 1, 1, 460, '如下图形，对应的代码是：\r\n![](/public/editoruploads/20220127/b8ab66c6204aab6673af2e1d3be17bee.png)', '{\"choices\":[\"b=\'88\'\",\"b = 46806816\",\"b = 88\",\"b = \'int\'\"]}', '[\"2\"]', 1, 500, 1, 1643268602, 1, 1673835543);
INSERT INTO `sub_question` VALUES (18, 1, 1, 1, 1, 1, 130, '如下关于变量和对象说法，错误的是:', '{\"choices\":[\"\\u53d8\\u91cf\\u4e5f\\u79f0\\u4e3a\\u5f15\\u7528\\uff08\\u5f15\\u7528\\u4e86\\u5bf9\\u8c61\\u7684\\u5730\\u5740\\uff09\",\"\\u53d8\\u91cf\\u548c\\u5bf9\\u8c61\\u90fd\\u4f4d\\u4e8e\\u5806\\u5185\\u5b58\",\"\\u53d8\\u91cf\\u6ca1\\u6709\\u7c7b\\u578b\\uff0c\\u5bf9\\u8c61\\u6709\\u7c7b\\u578b\",\"\\u53d8\\u91cf\\u4e0d\\u9700\\u8981\\u58f0\\u660e\\u7c7b\\u578b\\uff0c\\u89e3\\u91ca\\u5668\\u53ef\\u4ee5\\u81ea\\u52a8\\u786e\\u5b9a\\u6240\\u5f15\\u7528\\u5bf9\\u8c61\\u7684\\u7c7b\\u578b\"]}', '[\"1\"]', 1, 509, 1, 1643268938, 1, 1643268938);
INSERT INTO `sub_question` VALUES (19, 1, 1, 1, 1, 1, 430, '如下关于异常的代码，空白处填写的代码是：\r\n\r\n```python\r\n#测试简单的0不能做除数异常\r\n____:\r\n    print(\"step1\")\r\n    a = 3/0\r\n    print(\"step2\")\r\n_____ BaseException as e:\r\n    print(\"step3\")\r\n    print(____)\r\n\r\nprint(\"step4\")\r\n```', '{\"choices\":[\"`Try`      `Except`    `e`\",\"`try`      `except`    `e`\",\"`try`      `exception`    `e`\",\"`try`      `except`    `except`\"]}', '[\"1\"]', 1, 309, 1, 1643269441, 1, 1643269610);
INSERT INTO `sub_question` VALUES (20, 1, 1, 1, 1, 1, 250, '如下关于异常机制的代码，执行结果是\r\n```python\r\ntry:\r\n    b = 3/0\r\nexcept ZeroDivisionError:\r\n    print(\"异常：除数不能为0\")\r\nexcept BaseException:\r\n    print(\"程序有错误\")\r\n```', '{\"choices\":[\"\\u5f02\\u5e38\\uff1a\\u9664\\u6570\\u4e0d\\u80fd\\u4e3a0\",\"\\u7a0b\\u5e8f\\u6709\\u9519\\u8bef\",\"\\u5f02\\u5e38\\uff1a\\u9664\\u6570\\u4e0d\\u80fd\\u4e3a0\\uff1b \\u7a0b\\u5e8f\\u6709\\u9519\\u8bef\",\"\\u7a0b\\u5e8f\\u6709\\u9519\\u8bef\\uff1b \\u5f02\\u5e38\\uff1a\\u9664\\u6570\\u4e0d\\u80fd\\u4e3a0\"]}', '[\"0\"]', 1, 328, 1, 1643269741, 1, 1643269741);
INSERT INTO `sub_question` VALUES (21, 1, 1, 1, 1, 1, 370, '如下合法的标识符是:', '{\"choices\":[\"a#123\",\"100vip\",\"_good_student\",\"if\"]}', '[\"2\"]', 1, 526, 1, 1643269796, 1, 1643269796);
INSERT INTO `sub_question` VALUES (22, 1, 1, 1, 1, 1, 130, '如下关于异常的代码，直接结果正确的是\r\n```python\r\ntry:\r\n    b = 3/2\r\n    print(\"正在运算\")\r\nexcept BaseException:\r\n    print(\"0不能做除数\")\r\nelse:\r\n    print(\"除的结果是：\",b)\r\n```', '{\"choices\":[\"\\u6b63\\u5728\\u8fd0\\u7b97    \\t\\t\\u9664\\u7684\\u7ed3\\u679c\\u662f:1.5\",\"\\u6b63\\u5728\\u8fd0\\u7b97     \\t\\t0\\u4e0d\\u80fd\\u505a\\u9664\\u6570\",\"0\\u4e0d\\u80fd\\u505a\\u9664\\u6570\\t\",\"\\u9664\\u7684\\u7ed3\\u679c\\u662f\\uff1a1.5\"]}', '[\"0\"]', 1, 318, 1, 1643269925, 1, 1643269925);
INSERT INTO `sub_question` VALUES (23, 1, 1, 1, 1, 1, 310, '如下代码的运行，说法正确的是：\r\n```python\r\na=123\r\ndel a\r\nprint(a)\r\n```', '{\"choices\":[\"\\u53ef\\u4ee5\\u6b63\\u5e38\\u8fd0\\u884c\",\"\\u62a5\\u9519\\u3002a\\u6ca1\\u6709\\u88ab\\u5b9a\\u4e49\",\"\\u62a5\\u9519\\u3002\\u4e0d\\u80fd\\u5220\\u9664a\",\"\\u62a5\\u9519\\u3002a\\u4e0d\\u80fd\\u88ab\\u8d4b\\u503c123\"]}', '[\"1\"]', 1, 493, 1, 1643269952, 1, 1643269952);
INSERT INTO `sub_question` VALUES (24, 1, 1, 1, 1, 1, 370, '执行代码a,b,c=40,50,60，说法正确的是：', '{\"choices\":[\"a,b,c\\u7684\\u503c\\u662f\\u6700\\u540e\\u7684\\u503c\\uff1a60\",\"\\u53ea\\u6709a\\u88ab\\u8d4b\\u503c40\\u3002b\\u548cc\\u662f0\",\"a,b,c\\u7684\\u503c\\u662f\\u6700\\u521d\\u7684\\u503c\\uff1a40\",\"a\\u662f40\\uff0cb\\u662f50\\uff0cc\\u662f60\"]}', '[\"3\"]', 1, 523, 1, 1643270046, 1, 1643270046);
INSERT INTO `sub_question` VALUES (25, 1, 1, 1, 1, 1, 370, 'python中的常量，说法正确的是：', '{\"choices\":[\"python\\u4e2d\\u7684\\u5e38\\u91cf\\u662f\\u771f\\u7684\\u5e38\\u91cf\\uff0c\\u4e0d\\u80fd\\u4fee\\u6539\\u503c\",\"python\\u4e2d\\u7684\\u5e38\\u91cf\\u662f\\u903b\\u8f91\\u4e0a\\u7684\\u5e38\\u91cf\\uff0c\\u4ecd\\u7136\\u53ef\\u4ee5\\u4fee\\u6539\\u503c\",\"python\\u4e2d\\u7684\\u5e38\\u91cf\\u547d\\u540d\\u4e00\\u822c\\u662f\\u5c0f\\u5199\",\"python\\u4e2d\\u7684\\u5e38\\u91cf\\u547d\\u540d\\u4e00\\u822c\\u7528\\u9a7c\\u5cf0\\u539f\\u5219\\uff0c\\u6bd4\\u5982\\uff1aStudentNumber\"]}', '[\"1\"]', 1, 496, 1, 1643270104, 1, 1643270104);
INSERT INTO `sub_question` VALUES (26, 1, 1, 1, 1, 1, 530, ' 如下关于异常机制的代码，执行结果正确的是\r\n```python\r\ntry:\r\n    c = 3/0\r\n    print(\"step1\")\r\nexcept BaseException as  e:\r\n    print(\"step2\")\r\nelse:\r\n    print(\"step3\")\r\nfinally:\r\n    print(\"step4\")\r\n\r\nprint(\"step5\")\r\n```', '{\"choices\":[\"step1\\tstep2\\tstep4\\tstep5\",\"step2\\tstep4\\tstep5\",\"step1\\tstep3\\tstep4\\tstep5\",\"step1\\tstep2\\tstep4\\t\"]}', '[\"1\"]', 1, 319, 1, 1643270136, 1, 1643270199);
INSERT INTO `sub_question` VALUES (27, 1, 1, 1, 1, 1, 490, 'python中，内置的基本类型有哪些：', '{\"choices\":[\"\\u6574\\u578b\\u3001\\u6570\\u7ec4\\u3001\\u5e03\\u5c14\\u578b\\u3001\\u5b57\\u7b26\\u4e32\\u578b\",\"\\u6574\\u578b\\u3001\\u6d6e\\u70b9\\u578b\\u3001\\u5e03\\u5c14\\u578b\\u3001\\u5b57\\u7b26\\u578b\",\"\\u6574\\u578b\\u3001\\u6d6e\\u70b9\\u578b\\u3001\\u5e03\\u5c14\\u578b\\u3001\\u5b57\\u7b26\\u4e32\\u578b\",\"\\u6574\\u578b\\u3001\\u6570\\u7ec4\\u3001\\u5e03\\u5c14\\u578b\\u3001\\u5b57\\u7b26\\u578b\"]}', '[\"2\"]', 1, 487, 1, 1643270216, 1, 1643270216);
INSERT INTO `sub_question` VALUES (28, 1, 1, 1, 1, 1, 280, '如下异常信息对应的含义，说法错误的是', '{\"choices\":[\"SyntaxError\\uff1a\\u8bed\\u6cd5\\u9519\\u8bef\",\"ZeroDivisionError\\uff1a0\\u4e0d\\u80fd\\u505a\\u9664\\u6570\",\"IndexError\\uff1a\\u7f16\\u7801\\u9519\\u8bef\",\"IndentationError\\uff1a\\u7f29\\u8fdb\\u9519\\u8bef\"]}', '[\"2\"]', 1, 366, 1, 1643270277, 1, 1643270311);
INSERT INTO `sub_question` VALUES (29, 1, 1, 1, 1, 1, 490, '如下代码，运行结果是：\r\n```python\r\na = 7/2  \r\na = 7//2 \r\na = 7%2  \r\n```', '{\"choices\":[\"3, 3.5 3\",\"3.5, 3, 1\",\"3.5, 3, 3\",\"4, 3, 1\"]}', '[\"1\"]', 1, 523, 1, 1643270301, 1, 1643270301);
INSERT INTO `sub_question` VALUES (30, 1, 1, 1, 1, 1, 390, 'python3中，整数的表示范围是：', '{\"choices\":[\"\\u4efb\\u610f\\u5927\\uff0c\\u65e0\\u9650\\u5927\",\"\\u8868\\u793a\\u00b121\\u4ebf\\u8303\\u56f4\",\"\\u8868\\u793a\\u00b12\\u768464\\u6b21\\u65b9\\u8303\\u56f4\",\"\\u8868\\u793a0-65536\\u8303\\u56f4\"]}', '[\"0\"]', 1, 552, 1, 1643270417, 1, 1643270417);
COMMIT;

-- ----------------------------
-- Table structure for sub_testpaper
-- ----------------------------
DROP TABLE IF EXISTS `sub_testpaper`;
CREATE TABLE `sub_testpaper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `ques_id` varchar(255) NOT NULL,
  `start_time` int(10) NOT NULL,
  `updated_time` int(10) NOT NULL,
  `end_time` int(10) DEFAULT NULL,
  `used_time` int(11) NOT NULL DEFAULT '0' COMMENT '做题时间',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1代表完成 0代表未完成',
  `type` tinyint(4) NOT NULL DEFAULT '4' COMMENT '1复习 2错题 3收藏 4阶段选择',
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sub_user
-- ----------------------------
DROP TABLE IF EXISTS `sub_user`;
CREATE TABLE `sub_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `t_id` int(11) NOT NULL,
  `ques_id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1表示正确 2表示错误',
  `answer` varchar(255) NOT NULL,
  `start_time` int(10) NOT NULL,
  `last_time` int(10) NOT NULL,
  `times` int(11) NOT NULL DEFAULT '1' COMMENT '做题次数',
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sub_user_info
-- ----------------------------
DROP TABLE IF EXISTS `sub_user_info`;
CREATE TABLE `sub_user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `ques_id` int(11) NOT NULL,
  `start_time` int(10) NOT NULL,
  `last_time` int(10) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表收藏 2代表错题本',
  PRIMARY KEY (`id`),
  KEY `index_name_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type_desc` varchar(10000) CHARACTER SET utf8 NOT NULL,
  `type_sort` int(11) NOT NULL,
  `nav_id` int(11) NOT NULL,
  `number` int(3) NOT NULL DEFAULT '5' COMMENT '单元测试抽取题数',
  `is_free` varchar(11) NOT NULL DEFAULT '0' COMMENT '是否是试听 0是不免费 1是免费',
  `is_show` int(1) NOT NULL DEFAULT '1' COMMENT '1是显示 0是隐藏',
  PRIMARY KEY (`type_id`),
  KEY `index_name` (`nav_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of type
-- ----------------------------
BEGIN;
INSERT INTO `type` VALUES (1, 'Python基础课程', '本阶段是进入“程序员”的门槛，需要学习编程基本的知识。本阶段会从0开始，循序渐进。让小伙伴们认真学完本阶段，就会掌握：变量、数据类型、控制语句、容器、函数和面向对象等。教程中会穿插一些有趣的案例，寓教于乐，引起大家的兴趣。', 0, 1, 5, '0', 1);
INSERT INTO `type` VALUES (2, 'Python基础课程1', '本阶段是进入“程序员”的门槛，需要学习编程基本的知识。本阶段会从0开始，循序渐进。让小伙伴们认真学完本阶段，就会掌握：变量、数据类型、控制语句、容器、函数和面向对象等。教程中会穿插一些有趣的案例，寓教于乐，引起大家的兴趣。', 0, 1, 5, '0', 1);
INSERT INTO `type` VALUES (3, 'Python基础课程2', '本阶段是进入“程序员”的门槛，需要学习编程基本的知识。本阶段会从0开始，循序渐进。让小伙伴们认真学完本阶段，就会掌握：变量、数据类型、控制语句、容器、函数和面向对象等。教程中会穿插一些有趣的案例，寓教于乐，引起大家的兴趣。', 0, 1, 5, '0', 1);
COMMIT;

-- ----------------------------
-- View structure for user_log_view
-- ----------------------------
DROP VIEW IF EXISTS `user_log_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `user_log_view` AS select `course`.`course_id` AS `course_id`,`course`.`course_name` AS `course_name`,`course`.`s_id` AS `s_id`,`course`.`type_id` AS `type_id`,`course`.`course_sort` AS `course_sort`,`course`.`nav_id` AS `nav_id`,`course`.`is_must` AS `is_must`,`specific`.`s_name` AS `s_name`,`specific`.`s_show` AS `s_show`,`type`.`type_name` AS `type_name`,`type`.`is_show` AS `t_show`,`nav`.`nav_name` AS `nav_name`,`nav`.`nav_top_title` AS `nav_top_title`,`nav`.`is_show` AS `n_show`,`know_user_log`.`record` AS `record`,`know_user_log`.`time` AS `time`,`know_user_log`.`user_id` AS `user_id` from ((((`know_user_log` join `course` on((`course`.`course_id` = `know_user_log`.`course_id`))) join `type` on((`type`.`type_id` = `course`.`type_id`))) left join `specific` on((`specific`.`s_id` = `course`.`s_id`))) left join `nav` on((`nav`.`nav_id` = `course`.`nav_id`)));

SET FOREIGN_KEY_CHECKS = 1;
